create table TempUser
(
       TempUserID nvarchar2(50),
       UserName nvarchar2(20),
       StatusID integer,
       OrgName nvarchar2(200),
       Mobile nvarchar2(30),
       UserPassword nvarchar2(100),
       Telphone nvarchar2(20),
       IDCard nvarchar2(20),
       ApplyTime date,
       ExpirationTime date
)

create table CauseUserApplyList
(
       ApplyID nvarchar2(50),
       TempUserID nvarchar2(50),
       WellDataID nvarchar2(50),
       StatusID integer,
       ExpirationTime date
)